<?php

use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;

class CreateCustomerTable extends Migration {

	/**
	 * Run the migrations.
	 *
	 * @return void
	 */
	public function up()
	{
		Schema::create('customer', function(Blueprint $table)
		{
			$table->bigInteger('id', true)->unsigned();
			$table->string('number', 191)->comment('顾客号');
			$table->string('type', 191)->nullable()->comment('类型');
			$table->string('name', 191)->comment('姓名');
			$table->integer('gender')->nullable()->comment('性别');
			$table->string('birth_day', 191)->nullable()->comment('生日');
			$table->integer('job')->nullable()->comment('工作');
			$table->string('office', 191)->nullable()->comment('单位');
			$table->string('address', 191)->nullable()->comment('地址');
			$table->string('post', 191)->nullable()->comment('邮编');
			$table->string('phone', 191)->nullable()->comment('电话');
			$table->integer('visit_time')->nullable()->comment('来点次数');
			$table->integer('position')->comment('地点');
			$table->timestamps();
			$table->string('name_ug', 191)->nullable()->comment('名称');
			$table->integer('user_id')->nullable()->comment('登记的用户');
			$table->string('card_number', 191)->nullable()->comment('卡号');
			$table->string('patient_number', 191)->nullable()->comment('病历号');
			$table->integer('age')->nullable();
			$table->string('office_ug', 191)->nullable();
			$table->string('address_ug', 191)->nullable();
			$table->string('id_card', 191)->nullable();
			$table->string('server_id', 191)->nullable();
			$table->string('add_date', 191)->nullable();
			$table->string('original_number', 191)->nullable();
			$table->string('store_number', 191)->nullable();
			$table->integer('index')->nullable();
		});
	}


	/**
	 * Reverse the migrations.
	 *
	 * @return void
	 */
	public function down()
	{
		Schema::drop('customer');
	}

}
